namespace SmartSoft.ADP
{
    using System;
    using System.Data;
    using System.Data.SqlClient;

    public class ReportDataAccess
    {
        private WSReportDataAccess.WSReportDataAccess wDataAcess = new WSReportDataAccess.WSReportDataAccess();
        private SmartSoft.DAL.ReportDataAccess oDataAcess = new SmartSoft.DAL.ReportDataAccess();

        public ReportDataAccess()
        {
            wDataAcess.Url = wDataAcess.Url.Replace("localhost", AdapterInstance.ServerIp);
        }

        public DataTable DMVT02_Get(object ps_ParentCode)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.DMVT02_Get(ps_ParentCode);
            }
            else
            {
                table = oDataAcess.DMVT02_Get(ps_ParentCode);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable GetReportList(object ps_UserName, object ps_Groups)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.GetReportList(ps_UserName, ps_Groups);
            }
            else
            {
                table = oDataAcess.GetReportList(ps_UserName, ps_Groups);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KCD04_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Tk_154, object ps_Ma_Sp_Me, object ps_Ma_Sp, object ps_Tk_621, object ps_Tk_622, object ps_Tk_623, object ps_Tk_627, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KCD04_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Tk_154, ps_Ma_Sp_Me, ps_Ma_Sp, ps_Tk_621, ps_Tk_622, ps_Tk_623, ps_Tk_627, pi_English);
            }
            else
            {
                table = oDataAcess.KCD04_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Tk_154, ps_Ma_Sp_Me, ps_Ma_Sp, ps_Tk_621, ps_Tk_622, ps_Tk_623, ps_Tk_627, pi_English);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KCD20_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Sp_Me, object ps_Ma_Sp)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KCD20_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Sp_Me, ps_Ma_Sp);
            }
            else
            {
                table = oDataAcess.KCD20_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Sp_Me, ps_Ma_Sp);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KCT01_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Ct, object ps_Tk, object ps_Tk_Du, object ps_No_Co, object ps_Ma_Dt, object ps_Ma_Dt_Du, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KCT01_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Ct, ps_Tk, ps_Tk_Du, ps_No_Co, ps_Ma_Dt, ps_Ma_Dt_Du, pi_English);
            }
            else
            {
                table = oDataAcess.KCT01_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Ct, ps_Tk, ps_Tk_Du, ps_No_Co, ps_Ma_Dt, ps_Ma_Dt_Du, pi_English);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KCT01SC_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Ct, object ps_Tk, object ps_Tk_Du, object ps_No_Co, object ps_Ma_Dt, object ps_Ma_Dt_Du, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KCT01SC_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Ct, ps_Tk, ps_Tk_Du, ps_No_Co, ps_Ma_Dt, ps_Ma_Dt_Du, pi_English);
            }
            else
            {
                table = oDataAcess.KCT01SC_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Ct, ps_Tk, ps_Tk_Du, ps_No_Co, ps_Ma_Dt, ps_Ma_Dt_Du, pi_English);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KCT01T_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Tk, object pi_Bac_Tk, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KCT01T_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Tk, pi_Bac_Tk, pi_English);
            }
            else
            {
                table = oDataAcess.KCT01T_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Tk, pi_Bac_Tk, pi_English);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KCT02_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Yt, object ps_Ma_Sp_Me, object ps_Ma_Sp, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KCT02_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Yt, ps_Ma_Sp_Me, ps_Ma_Sp, pi_English);
            }
            else
            {
                table = oDataAcess.KCT02_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Yt, ps_Ma_Sp_Me, ps_Ma_Sp, pi_English);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KCT02A_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Tk, object ps_Ma_Sp_Me, object ps_Ma_Sp, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KCT02A_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Tk, ps_Ma_Sp_Me, ps_Ma_Sp, pi_English);
            }
            else
            {
                table = oDataAcess.KCT02A_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Tk, ps_Ma_Sp_Me, ps_Ma_Sp, pi_English);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KCT03_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Tk, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KCT03_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Tk, pi_English);
            }
            else
            {
                table = oDataAcess.KCT03_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Tk, pi_English);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KCT04_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Tk, object ps_Ma_Nh_Dt, object ps_Ma_Dt, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KCT04_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Tk, ps_Ma_Nh_Dt, ps_Ma_Dt, pi_English);
            }
            else
            {
                table = oDataAcess.KCT04_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Tk, ps_Ma_Nh_Dt, ps_Ma_Dt, pi_English);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KCT04A_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Tk, object ps_Ma_Nh_Dt, object ps_Ma_Dt, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KCT04A_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Tk, ps_Ma_Nh_Dt, ps_Ma_Dt, pi_English);
            }
            else
            {
                table = oDataAcess.KCT04A_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Tk, ps_Ma_Nh_Dt, ps_Ma_Dt, pi_English);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KCT04B_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Tk, object ps_Ma_Nh_Dt, object ps_Ma_Dt, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KCT04B_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Tk, ps_Ma_Nh_Dt, ps_Ma_Dt, pi_English);
            }
            else
            {
                table = oDataAcess.KCT04B_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Tk, ps_Ma_Nh_Dt, ps_Ma_Dt, pi_English);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KCT06_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Ct, object ps_So_Ct1, object ps_So_Ct2, object ps_Tk, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KCT06_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Ct, ps_So_Ct1, ps_So_Ct2, ps_Tk, pi_English);
            }
            else
            {
                table = oDataAcess.KCT06_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Ct, ps_So_Ct1, ps_So_Ct2, ps_Tk, pi_English);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KCT071_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Tk_133, object ps_HD_Huy, ref object pi_TTien, ref object pi_TTien3, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KCT071_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Tk_133, ps_HD_Huy, ref pi_TTien, ref pi_TTien3, pi_English);
            }
            else
            {
                table = oDataAcess.KCT071_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Tk_133, ps_HD_Huy, ref pi_TTien, ref pi_TTien3, pi_English);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KCT072_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Tk_3331, object ps_HD_Huy, ref object pi_TTien, ref object pi_TTien3, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KCT072_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Tk_3331, ps_HD_Huy, ref pi_TTien, ref pi_TTien3, pi_English);
            }
            else
            {
                table = oDataAcess.KCT072_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Tk_3331, ps_HD_Huy, ref pi_TTien, ref pi_TTien3, pi_English);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KCT073_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Tk_133, object ps_HD_Huy, ref object pi_TTien, ref object pi_TTien3, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KCT073_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Tk_133, ps_HD_Huy, ref pi_TTien, ref pi_TTien3, pi_English);
            }
            else
            {
                table = oDataAcess.KCT073_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Tk_133, ps_HD_Huy, ref pi_TTien, ref pi_TTien3, pi_English);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KCT074_Get(object pd_Ngay_Ct1, object pd_Ngay_Ct2)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KCT074_Get(pd_Ngay_Ct1, pd_Ngay_Ct2);
            }
            else
            {
                table = oDataAcess.KCT074_Get(pd_Ngay_Ct1, pd_Ngay_Ct2);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KCT10_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Ct, object ps_So_Ct1, object ps_So_Ct2, object pi_TTien_Nt1, object pi_TTien_Nt2, object ps_Tk, object ps_Tk_Du, object ps_No_Co, object ps_Ma_Dt, object ps_Ma_Hd, object ps_Ma_Bp, object ps_Ma_Km, object ps_Ma_Sp, object ps_Dien_Giai, object ps_Desc_EN, object ps_Ong_Ba, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KCT10_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Ct, ps_So_Ct1, ps_So_Ct2, pi_TTien_Nt1, pi_TTien_Nt2, ps_Tk, ps_Tk_Du, ps_No_Co, ps_Ma_Dt, ps_Ma_Hd, ps_Ma_Bp, ps_Ma_Km, ps_Ma_Sp, ps_Dien_Giai, ps_Desc_EN, ps_Ong_Ba, pi_English);
            }
            else
            {
                table = oDataAcess.KCT10_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Ct, ps_So_Ct1, ps_So_Ct2, pi_TTien_Nt1, pi_TTien_Nt2, ps_Tk, ps_Tk_Du, ps_No_Co, ps_Ma_Dt, ps_Ma_Hd, ps_Ma_Bp, ps_Ma_Km, ps_Ma_Sp, ps_Dien_Giai, ps_Desc_EN, ps_Ong_Ba, pi_English);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KCT11_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Tk_621, object ps_Tk_622, object ps_Tk_623, object ps_Tk_627, object ps_Tk_635, object ps_Tk_641, object ps_Tk_642, object ps_Tk_List, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KCT11_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Tk_621, ps_Tk_622, ps_Tk_623, ps_Tk_627, ps_Tk_635, ps_Tk_641, ps_Tk_642, ps_Tk_List, pi_English);
            }
            else
            {
                table = oDataAcess.KCT11_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Tk_621, ps_Tk_622, ps_Tk_623, ps_Tk_627, ps_Tk_635, ps_Tk_641, ps_Tk_642, ps_Tk_List, pi_English);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KCT12_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Tk, object ps_No_Co, ref object ps_Tk_Du1, ref object ps_Tk_Du2, ref object ps_Tk_Du3, ref object ps_Tk_Du4, ref object ps_Tk_Du5, ref object ps_Tk_Du6, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KCT12_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Tk, ps_No_Co, ref ps_Tk_Du1, ref ps_Tk_Du2, ref ps_Tk_Du3, ref ps_Tk_Du4, ref ps_Tk_Du5, ref ps_Tk_Du6, pi_English);
            }
            else
            {
                table = oDataAcess.KCT12_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Tk, ps_No_Co, ref ps_Tk_Du1, ref ps_Tk_Du2, ref ps_Tk_Du3, ref ps_Tk_Du4, ref ps_Tk_Du5, ref ps_Tk_Du6, pi_English);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KQT01_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object pd_Ngay_Bd_Ht, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KQT01_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, pd_Ngay_Bd_Ht, pi_English);
            }
            else
            {
                table = oDataAcess.KQT01_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, pd_Ngay_Bd_Ht, pi_English);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KQT02_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object pd_Ngay_Ct0, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KQT02_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, pd_Ngay_Ct0, pi_English);
            }
            else
            {
                table = oDataAcess.KQT02_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, pd_Ngay_Ct0, pi_English);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KQT031_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object pd_Ngay_Ct0, object ps_Tk_List, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KQT031_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, pd_Ngay_Ct0, ps_Tk_List, pi_English);
            }
            else
            {
                table = oDataAcess.KQT031_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, pd_Ngay_Ct0, ps_Tk_List, pi_English);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KQT032_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object pd_Ngay_Ct0, object ps_Tk_List0, object ps_Tk_List1, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KQT032_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, pd_Ngay_Ct0, ps_Tk_List0, ps_Tk_List1, pi_English);
            }
            else
            {
                table = oDataAcess.KQT032_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, pd_Ngay_Ct0, ps_Tk_List0, ps_Tk_List1, pi_English);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KQT05_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object pi_Tien_DN, ref object ps_Mua_Ban_Ck, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KQT05_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, pi_Tien_DN, ref ps_Mua_Ban_Ck, pi_English);
            }
            else
            {
                table = oDataAcess.KQT05_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, pi_Tien_DN, ref ps_Mua_Ban_Ck, pi_English);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KTH01_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Ct, object ps_Tk, object pi_Bac_Tk, object ps_Tk_Du, object ps_No_Co, object ps_Ma_Dt, object ps_Ma_Dt_Du, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KTH01_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Ct, ps_Tk, pi_Bac_Tk, ps_Tk_Du, ps_No_Co, ps_Ma_Dt, ps_Ma_Dt_Du, pi_English);
            }
            else
            {
                table = oDataAcess.KTH01_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Ct, ps_Tk, pi_Bac_Tk, ps_Tk_Du, ps_No_Co, ps_Ma_Dt, ps_Ma_Dt_Du, pi_English);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KTH02_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Tk, object ps_Ma_Dt, object ps_Ma_Nh_Dt, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KTH02_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Tk, ps_Ma_Dt, ps_Ma_Nh_Dt, pi_English);
            }
            else
            {
                table = oDataAcess.KTH02_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Tk, ps_Ma_Dt, ps_Ma_Nh_Dt, pi_English);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KTH03A_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Sp_Me, object ps_Ma_Sp, object ps_Tk_641, object ps_Tk_642, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KTH03A_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Sp_Me, ps_Ma_Sp, ps_Tk_641, ps_Tk_642, pi_English);
            }
            else
            {
                table = oDataAcess.KTH03A_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Sp_Me, ps_Ma_Sp, ps_Tk_641, ps_Tk_642, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KTH03B_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Sp_Me, object ps_Ma_Sp, object ps_Kieu_BC, object ps_Kieu_Gia, object ps_Lay_DD, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KTH03B_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Sp_Me, ps_Ma_Sp, ps_Kieu_BC, ps_Kieu_Gia, ps_Lay_DD, pi_English);
            }
            else
            {
                table = oDataAcess.KTH03B_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Sp_Me, ps_Ma_Sp, ps_Kieu_BC, ps_Kieu_Gia, ps_Lay_DD, pi_English);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KTH03C_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Sp_Me, object ps_Ma_Sp, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KTH03C_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Sp_Me, ps_Ma_Sp, pi_English);
            }
            else
            {
                table = oDataAcess.KTH03C_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Sp_Me, ps_Ma_Sp, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KTH03E_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Sp_Me, object ps_Ma_Sp, object ps_Kieu_BC, object ps_Kieu_Gia, object ps_Lay_DD, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KTH03E_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Sp_Me, ps_Ma_Sp, ps_Kieu_BC, ps_Kieu_Gia, ps_Lay_DD, pi_English);
            }
            else
            {
                table = oDataAcess.KTH03E_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Sp_Me, ps_Ma_Sp, ps_Kieu_BC, ps_Kieu_Gia, ps_Lay_DD, pi_English);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KTH03H_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Sp_Me, object ps_Ma_Sp, object ps_Kieu_BC, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KTH03H_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Sp_Me, ps_Ma_Sp, ps_Kieu_BC, pi_English);
            }
            else
            {
                table = oDataAcess.KTH03H_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Sp_Me, ps_Ma_Sp, ps_Kieu_BC, pi_English);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KTH04_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Tk_List, object ps_No_Co, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KTH04_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Tk_List, ps_No_Co, pi_English);
            }
            else
            {
                table = oDataAcess.KTH04_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Tk_List, ps_No_Co, pi_English);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KTH05_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Sp_Me, object ps_Ma_Sp, object ps_Ma_Yt, object ps_Ma_Dm_Sp, object ps_UserName, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KTH05_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Sp_Me, ps_Ma_Sp, ps_Ma_Yt, ps_Ma_Dm_Sp, ps_UserName, pi_English);
            }
            else
            {
                table = oDataAcess.KTH05_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Sp_Me, ps_Ma_Sp, ps_Ma_Yt, ps_Ma_Dm_Sp, ps_UserName, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KTH05A_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Sp_Me, object ps_Ma_Sp, object ps_Ma_Yt, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KTH05A_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Sp_Me, ps_Ma_Sp, ps_Ma_Yt, pi_English);
            }
            else
            {
                table = oDataAcess.KTH05A_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Sp_Me, ps_Ma_Sp, ps_Ma_Yt, pi_English);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KTH06_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Yt, object ps_Ma_Sp_Me, object ps_Ma_Sp, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KTH06_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Yt, ps_Ma_Sp_Me, ps_Ma_Sp, pi_English);
            }
            else
            {
                table = oDataAcess.KTH06_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Yt, ps_Ma_Sp_Me, ps_Ma_Sp, pi_English);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KTH06A_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Tk, object ps_Ma_Sp_Me, object ps_Ma_Sp, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KTH06A_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Tk, ps_Ma_Sp_Me, ps_Ma_Sp, pi_English);
            }
            else
            {
                table = oDataAcess.KTH06A_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Tk, ps_Ma_Sp_Me, ps_Ma_Sp, pi_English);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KTH08_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Tk, object ps_Tk_List, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KTH08_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Tk, ps_Tk_List, pi_English);
            }
            else
            {
                table = oDataAcess.KTH08_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Tk, ps_Tk_List, pi_English);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KTH09_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object pi_Revenue, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KTH09_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, pi_Revenue, pi_English);
            }
            else
            {
                table = oDataAcess.KTH09_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, pi_Revenue, pi_English);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KTH10_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Tk_CP_List, object ps_Tk_GT_List, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KTH10_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Tk_CP_List, ps_Tk_GT_List, pi_English);
            }
            else
            {
                table = oDataAcess.KTH10_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Tk_CP_List, ps_Tk_GT_List, pi_English);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KTH10A_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Tk_621, object ps_Tk_622, object ps_Tk_623, object ps_Tk_627, object ps_Tk_635, object ps_Tk_641, object ps_Tk_642, object ps_Tk_List, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KTH10A_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Tk_621, ps_Tk_622, ps_Tk_623, ps_Tk_627, ps_Tk_635, ps_Tk_641, ps_Tk_642, ps_Tk_List, pi_English);
            }
            else
            {
                table = oDataAcess.KTH10A_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Tk_621, ps_Tk_622, ps_Tk_623, ps_Tk_627, ps_Tk_635, ps_Tk_641, ps_Tk_642, ps_Tk_List, pi_English);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KTS01_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Bp, object ps_Ma_Nh_Ts, object ps_Ma_Ts, object ps_Loai_Ts, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KTS01_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Bp, ps_Ma_Nh_Ts, ps_Ma_Ts, ps_Loai_Ts, pi_English);
            }
            else
            {
                table = oDataAcess.KTS01_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Bp, ps_Ma_Nh_Ts, ps_Ma_Ts, ps_Loai_Ts, pi_English);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable TKTS_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Bp, object ps_Ma_Nh_Ts, object ps_Ma_Ts, object ps_Loai_Ts, object pi_English)
        {
            DataTable table = null; if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.TKTS_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Bp, ps_Ma_Nh_Ts, ps_Ma_Ts, ps_Loai_Ts, pi_English);
            }
            else
            {
                table = oDataAcess.TKTS_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Bp, ps_Ma_Nh_Ts, ps_Ma_Ts, ps_Loai_Ts, pi_English);
            } if (table != null) table.TableName = string.Empty;
            return table;
        }
        
        //CuongBM
        public DataTable BBKK_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.BBKK_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, pi_English);
            }
            else
            {
                table = oDataAcess.BBKK_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }

        public int SaveReportRow(bool pb_NewChecked, ref object pi_Stt, object pi_Stt0, object ps_Bar, object ps_Bar_E, object ps_Title, object ps_Title_E, object ps_FormFile, object ps_RepoFile, object ps_RepoGrp, object ps_Series, object pb_OnTop)
        {
            if (AdapterInstance.IsRemoteConnected)
            {
                return wDataAcess.SaveReportRow(pb_NewChecked, ref pi_Stt, pi_Stt0, ps_Bar, ps_Bar_E, ps_Title, ps_Title_E, ps_FormFile, ps_RepoFile, ps_RepoGrp, ps_Series, pb_OnTop);
            }
            else
            {
                return oDataAcess.SaveReportRow(pb_NewChecked, ref pi_Stt, pi_Stt0, ps_Bar, ps_Bar_E, ps_Title, ps_Title_E, ps_FormFile, ps_RepoFile, ps_RepoGrp, ps_Series, pb_OnTop);
            }
        }

        public DataTable VCD01_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Kho, object ps_Ma_Nh_Vt, object ps_Ma_Vt, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.VCD01_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Kho, ps_Ma_Nh_Vt, ps_Ma_Vt, pi_English);
            }
            else
            {
                table = oDataAcess.VCD01_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Kho, ps_Ma_Nh_Vt, ps_Ma_Vt, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable VCD02_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object ps_Ma_Kho, object ps_Ma_Nh_Vt, object ps_Ma_Vt, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.VCD02_Get(ps_Subsidiaries, pd_Ngay_Ct1, ps_Ma_Kho, ps_Ma_Nh_Vt, ps_Ma_Vt, pi_English);
            }
            else
            {
                table = oDataAcess.VCD02_Get(ps_Subsidiaries, pd_Ngay_Ct1, ps_Ma_Kho, ps_Ma_Nh_Vt, ps_Ma_Vt, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable VCD02A_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object ps_Ma_Kho, object ps_Ma_Nh_Vt, object ps_Ma_Vt, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.VCD02A_Get(ps_Subsidiaries, pd_Ngay_Ct1, ps_Ma_Kho, ps_Ma_Nh_Vt, ps_Ma_Vt, pi_English);
            }
            else
            {
                table = oDataAcess.VCD02A_Get(ps_Subsidiaries, pd_Ngay_Ct1, ps_Ma_Kho, ps_Ma_Nh_Vt, ps_Ma_Vt, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable VCT00HD_Get(object ps_Subsidiaries, object ps_Nh_Ct, object ps_Ma_Ct_List, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_So_Ct1, object ps_So_Ct2, object pi_Tien1, object pi_Tien2, object ps_Ma_Dt, object ps_Dien_Giai, object ps_Desc_EN, object ps_Ma_Nh_Vt, object ps_Ma_Kho, object ps_Ma_Vt, object ps_Ma_Bp, object ps_Ma_Hd, object ps_Ma_Km, object ps_Ma_Nx, object ps_Tk_No, object ps_Tk_Co, object ps_Ong_Ba, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.VCT00HD_Get(ps_Subsidiaries, ps_Nh_Ct, ps_Ma_Ct_List, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_So_Ct1, ps_So_Ct2, pi_Tien1, pi_Tien2, ps_Ma_Dt, ps_Dien_Giai, ps_Desc_EN, ps_Ma_Nh_Vt, ps_Ma_Kho, ps_Ma_Vt, ps_Ma_Bp, ps_Ma_Hd, ps_Ma_Km, ps_Ma_Nx, ps_Tk_No, ps_Tk_Co, ps_Ong_Ba, pi_English);
            }
            else
            {
                table = oDataAcess.VCT00HD_Get(ps_Subsidiaries, ps_Nh_Ct, ps_Ma_Ct_List, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_So_Ct1, ps_So_Ct2, pi_Tien1, pi_Tien2, ps_Ma_Dt, ps_Dien_Giai, ps_Desc_EN, ps_Ma_Nh_Vt, ps_Ma_Kho, ps_Ma_Vt, ps_Ma_Bp, ps_Ma_Hd, ps_Ma_Km, ps_Ma_Nx, ps_Tk_No, ps_Tk_Co, ps_Ong_Ba, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable VCT00N_Get(object ps_Subsidiaries, object ps_Ma_Ct_List, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_So_Ct1, object ps_So_Ct2, object pi_Tien1, object pi_Tien2, object ps_Ma_Dt, object ps_Dien_Giai, object ps_Desc_EN, object ps_Ma_Nh_Vt, object ps_Ma_Kho, object ps_Ma_Vt, object ps_Ma_Bp, object ps_Ma_Sp, object ps_Ma_Hd, object ps_Ma_Km, object ps_Ma_Nx, object ps_Tk_No, object ps_Tk_Co, object ps_Ong_Ba, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.VCT00N_Get(ps_Subsidiaries, ps_Ma_Ct_List, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_So_Ct1, ps_So_Ct2, pi_Tien1, pi_Tien2, ps_Ma_Dt, ps_Dien_Giai, ps_Desc_EN, ps_Ma_Nh_Vt, ps_Ma_Kho, ps_Ma_Vt, ps_Ma_Bp, ps_Ma_Sp, ps_Ma_Hd, ps_Ma_Km, ps_Ma_Nx, ps_Tk_No, ps_Tk_Co, ps_Ong_Ba, pi_English);
            }
            else
            {
                table = oDataAcess.VCT00N_Get(ps_Subsidiaries, ps_Ma_Ct_List, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_So_Ct1, ps_So_Ct2, pi_Tien1, pi_Tien2, ps_Ma_Dt, ps_Dien_Giai, ps_Desc_EN, ps_Ma_Nh_Vt, ps_Ma_Kho, ps_Ma_Vt, ps_Ma_Bp, ps_Ma_Sp, ps_Ma_Hd, ps_Ma_Km, ps_Ma_Nx, ps_Tk_No, ps_Tk_Co, ps_Ong_Ba, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable VCT00X_Get(object ps_Subsidiaries, object ps_Ma_Ct_List, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_So_Ct1, object ps_So_Ct2, object pi_Tien1, object pi_Tien2, object ps_Ma_Dt, object ps_Dien_Giai, object ps_Desc_EN, object ps_Ma_Nh_Vt, object ps_Ma_Kho, object ps_Ma_Vt, object ps_Ma_Bp, object ps_Ma_Sp, object ps_Ma_Hd, object ps_Ma_Km, object ps_Ma_Nx, object ps_Tk_No, object ps_Tk_Co, object ps_Ong_Ba, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.VCT00X_Get(ps_Subsidiaries, ps_Ma_Ct_List, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_So_Ct1, ps_So_Ct2, pi_Tien1, pi_Tien2, ps_Ma_Dt, ps_Dien_Giai, ps_Desc_EN, ps_Ma_Nh_Vt, ps_Ma_Kho, ps_Ma_Vt, ps_Ma_Bp, ps_Ma_Sp, ps_Ma_Hd, ps_Ma_Km, ps_Ma_Nx, ps_Tk_No, ps_Tk_Co, ps_Ong_Ba, pi_English);
            }
            else
            {
                table = oDataAcess.VCT00X_Get(ps_Subsidiaries, ps_Ma_Ct_List, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_So_Ct1, ps_So_Ct2, pi_Tien1, pi_Tien2, ps_Ma_Dt, ps_Dien_Giai, ps_Desc_EN, ps_Ma_Nh_Vt, ps_Ma_Kho, ps_Ma_Vt, ps_Ma_Bp, ps_Ma_Sp, ps_Ma_Hd, ps_Ma_Km, ps_Ma_Nx, ps_Tk_No, ps_Tk_Co, ps_Ong_Ba, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable VCT01_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Kho, object ps_Ma_Vt, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.VCT01_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Kho, ps_Ma_Vt, pi_English);
            }
            else
            {
                table = oDataAcess.VCT01_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Kho, ps_Ma_Vt, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable VCT01M10_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Kho, object ps_Ma_Vt, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                //table = wDataAcess
                table = wDataAcess.VCT01_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Kho, ps_Ma_Vt, pi_English);
            }
            else
            {
                table = oDataAcess.VCT01M10_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Kho, ps_Ma_Vt, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }
        public DataTable VCT01HD_Get(object ps_Subsidiaries, object ps_Ma_Ct_List, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_So_Ct1, object ps_So_Ct2, object pi_Tien1, object pi_Tien2, object ps_Ma_Dt, object ps_Dien_Giai, object ps_Desc_EN, object ps_Ma_Nh_Vt, object ps_Ma_Kho, object ps_Ma_Vt, object ps_Ma_Bp, object ps_Ma_Hd, object ps_Ma_Km, object ps_Ma_Nx, object ps_Tk_No, object ps_Tk_Co, object ps_Ong_Ba, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.VCT01HD_Get(ps_Subsidiaries, ps_Ma_Ct_List, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_So_Ct1, ps_So_Ct2, pi_Tien1, pi_Tien2, ps_Ma_Dt, ps_Dien_Giai, ps_Desc_EN, ps_Ma_Nh_Vt, ps_Ma_Kho, ps_Ma_Vt, ps_Ma_Bp, ps_Ma_Hd, ps_Ma_Km, ps_Ma_Nx, ps_Tk_No, ps_Tk_Co, ps_Ong_Ba, pi_English);
            }
            else
            {
                table = oDataAcess.VCT01HD_Get(ps_Subsidiaries, ps_Ma_Ct_List, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_So_Ct1, ps_So_Ct2, pi_Tien1, pi_Tien2, ps_Ma_Dt, ps_Dien_Giai, ps_Desc_EN, ps_Ma_Nh_Vt, ps_Ma_Kho, ps_Ma_Vt, ps_Ma_Bp, ps_Ma_Hd, ps_Ma_Km, ps_Ma_Nx, ps_Tk_No, ps_Tk_Co, ps_Ong_Ba, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable VCT01N_Get(object ps_Subsidiaries, object ps_Ma_Ct_List, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_So_Ct1, object ps_So_Ct2, object pi_Tien1, object pi_Tien2, object ps_Ma_Dt, object ps_Dien_Giai, object ps_Desc_EN, object ps_Ma_Nh_Vt, object ps_Ma_Kho, object ps_Ma_Vt, object ps_Ma_Bp, object ps_Ma_Sp, object ps_Ma_Hd, object ps_Ma_Km, object ps_Ma_Nx, object ps_Tk_No, object ps_Tk_Co, object ps_Ong_Ba, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.VCT01N_Get(ps_Subsidiaries, ps_Ma_Ct_List, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_So_Ct1, ps_So_Ct2, pi_Tien1, pi_Tien2, ps_Ma_Dt, ps_Dien_Giai, ps_Desc_EN, ps_Ma_Nh_Vt, ps_Ma_Kho, ps_Ma_Vt, ps_Ma_Bp, ps_Ma_Sp, ps_Ma_Hd, ps_Ma_Km, ps_Ma_Nx, ps_Tk_No, ps_Tk_Co, ps_Ong_Ba, pi_English);
            }
            else
            {
                table = oDataAcess.VCT01N_Get(ps_Subsidiaries, ps_Ma_Ct_List, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_So_Ct1, ps_So_Ct2, pi_Tien1, pi_Tien2, ps_Ma_Dt, ps_Dien_Giai, ps_Desc_EN, ps_Ma_Nh_Vt, ps_Ma_Kho, ps_Ma_Vt, ps_Ma_Bp, ps_Ma_Sp, ps_Ma_Hd, ps_Ma_Km, ps_Ma_Nx, ps_Tk_No, ps_Tk_Co, ps_Ong_Ba, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable VCT01X_Get(object ps_Subsidiaries, object ps_Ma_Ct_List, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_So_Ct1, object ps_So_Ct2, object pi_Tien1, object pi_Tien2, object ps_Ma_Dt, object ps_Dien_Giai, object ps_Desc_EN, object ps_Ma_Nh_Vt, object ps_Ma_Kho, object ps_Ma_Vt, object ps_Ma_Bp, object ps_Ma_Sp, object ps_Ma_Hd, object ps_Ma_Km, object ps_Ma_Nx, object ps_Tk_No, object ps_Tk_Co, object ps_Ong_Ba, object ps_Tk_621, object ps_Tk_627, object ps_Tk_632, object ps_Tk_641, object ps_Tk_642, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.VCT01X_Get(ps_Subsidiaries, ps_Ma_Ct_List, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_So_Ct1, ps_So_Ct2, pi_Tien1, pi_Tien2, ps_Ma_Dt, ps_Dien_Giai, ps_Desc_EN, ps_Ma_Nh_Vt, ps_Ma_Kho, ps_Ma_Vt, ps_Ma_Bp, ps_Ma_Sp, ps_Ma_Hd, ps_Ma_Km, ps_Ma_Nx, ps_Tk_No, ps_Tk_Co, ps_Ong_Ba, ps_Tk_621, ps_Tk_627, ps_Tk_632, ps_Tk_641, ps_Tk_642, pi_English);
            }
            else
            {
                table = oDataAcess.VCT01X_Get(ps_Subsidiaries, ps_Ma_Ct_List, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_So_Ct1, ps_So_Ct2, pi_Tien1, pi_Tien2, ps_Ma_Dt, ps_Dien_Giai, ps_Desc_EN, ps_Ma_Nh_Vt, ps_Ma_Kho, ps_Ma_Vt, ps_Ma_Bp, ps_Ma_Sp, ps_Ma_Hd, ps_Ma_Km, ps_Ma_Nx, ps_Tk_No, ps_Tk_Co, ps_Ong_Ba, ps_Tk_621, ps_Tk_627, ps_Tk_632, ps_Tk_641, ps_Tk_642, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable VTH01HDA_Get(object ps_Subsidiaries, object ps_Ma_Ct_List, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_So_Ct1, object ps_So_Ct2, object pi_Tien1, object pi_Tien2, object ps_Ma_Dt, object ps_Ma_Kho, object ps_Ma_Nh_Vt, object ps_Ma_Vt, object ps_Ma_Bp, object ps_Ma_Hd, object ps_Ma_Km, object ps_Ma_Nx, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.VTH01HDA_Get(ps_Subsidiaries, ps_Ma_Ct_List, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_So_Ct1, ps_So_Ct2, pi_Tien1, pi_Tien2, ps_Ma_Dt, ps_Ma_Kho, ps_Ma_Nh_Vt, ps_Ma_Vt, ps_Ma_Bp, ps_Ma_Hd, ps_Ma_Km, ps_Ma_Nx, pi_English);
            }
            else
            {
                table = oDataAcess.VTH01HDA_Get(ps_Subsidiaries, ps_Ma_Ct_List, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_So_Ct1, ps_So_Ct2, pi_Tien1, pi_Tien2, ps_Ma_Dt, ps_Ma_Kho, ps_Ma_Nh_Vt, ps_Ma_Vt, ps_Ma_Bp, ps_Ma_Hd, ps_Ma_Km, ps_Ma_Nx, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable VTH01HDB_Get(object ps_Subsidiaries, object ps_Ma_Ct_List, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_So_Ct1, object ps_So_Ct2, object pi_Tien1, object pi_Tien2, object ps_Ma_Dt, object ps_Ma_Kho, object ps_Ma_Nh_Vt, object ps_Ma_Vt, object ps_Ma_Bp, object ps_Ma_Hd, object ps_Ma_Km, object ps_Ma_Nx, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.VTH01HDB_Get(ps_Subsidiaries, ps_Ma_Ct_List, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_So_Ct1, ps_So_Ct2, pi_Tien1, pi_Tien2, ps_Ma_Dt, ps_Ma_Kho, ps_Ma_Nh_Vt, ps_Ma_Vt, ps_Ma_Bp, ps_Ma_Hd, ps_Ma_Km, ps_Ma_Nx, pi_English);
            }
            else
            {
                table = oDataAcess.VTH01HDB_Get(ps_Subsidiaries, ps_Ma_Ct_List, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_So_Ct1, ps_So_Ct2, pi_Tien1, pi_Tien2, ps_Ma_Dt, ps_Ma_Kho, ps_Ma_Nh_Vt, ps_Ma_Vt, ps_Ma_Bp, ps_Ma_Hd, ps_Ma_Km, ps_Ma_Nx, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable VTH01N_Get(object ps_Subsidiaries, object ps_Ma_Ct_List, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_So_Ct1, object ps_So_Ct2, object pi_Tien1, object pi_Tien2, object ps_Ma_Dt, object ps_Ma_Nh_Vt, object ps_Ma_Kho, object ps_Ma_Vt, object ps_Ma_Bp, object ps_Ma_Sp, object ps_Ma_Hd, object ps_Ma_Km, object ps_Ma_Nx, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.VTH01N_Get(ps_Subsidiaries, ps_Ma_Ct_List, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_So_Ct1, ps_So_Ct2, pi_Tien1, pi_Tien2, ps_Ma_Dt, ps_Ma_Nh_Vt, ps_Ma_Kho, ps_Ma_Vt, ps_Ma_Bp, ps_Ma_Sp, ps_Ma_Hd, ps_Ma_Km, ps_Ma_Nx, pi_English);
            }
            else
            {
                table = oDataAcess.VTH01N_Get(ps_Subsidiaries, ps_Ma_Ct_List, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_So_Ct1, ps_So_Ct2, pi_Tien1, pi_Tien2, ps_Ma_Dt, ps_Ma_Nh_Vt, ps_Ma_Kho, ps_Ma_Vt, ps_Ma_Bp, ps_Ma_Sp, ps_Ma_Hd, ps_Ma_Km, ps_Ma_Nx, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable VTH01X_Get(object ps_Subsidiaries, object ps_Ma_Ct_List, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_So_Ct1, object ps_So_Ct2, object pi_Tien1, object pi_Tien2, object ps_Ma_Dt, object ps_Ma_Nh_Vt, object ps_Ma_Kho, object ps_Ma_Vt, object ps_Ma_Bp, object ps_Ma_Sp, object ps_Ma_Hd, object ps_Ma_Km, object ps_Ma_Nx, object ps_Tk_621, object ps_Tk_627, object ps_Tk_632, object ps_Tk_641, object ps_Tk_642, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.VTH01X_Get(ps_Subsidiaries, ps_Ma_Ct_List, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_So_Ct1, ps_So_Ct2, pi_Tien1, pi_Tien2, ps_Ma_Dt, ps_Ma_Nh_Vt, ps_Ma_Kho, ps_Ma_Vt, ps_Ma_Bp, ps_Ma_Sp, ps_Ma_Hd, ps_Ma_Km, ps_Ma_Nx, ps_Tk_621, ps_Tk_627, ps_Tk_632, ps_Tk_641, ps_Tk_642, pi_English);
            }
            else
            {
                table = oDataAcess.VTH01X_Get(ps_Subsidiaries, ps_Ma_Ct_List, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_So_Ct1, ps_So_Ct2, pi_Tien1, pi_Tien2, ps_Ma_Dt, ps_Ma_Nh_Vt, ps_Ma_Kho, ps_Ma_Vt, ps_Ma_Bp, ps_Ma_Sp, ps_Ma_Hd, ps_Ma_Km, ps_Ma_Nx, ps_Tk_621, ps_Tk_627, ps_Tk_632, ps_Tk_641, ps_Tk_642, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable VTH02A_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Nh_Dt, object ps_Ma_Dt, object ps_Ma_Nh_Vt, object ps_Ma_Vt, object ps_Tk_641, object ps_Tk_642, object ps_Loai_PB, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.VTH02A_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Nh_Dt, ps_Ma_Dt, ps_Ma_Nh_Vt, ps_Ma_Vt, ps_Tk_641, ps_Tk_642, ps_Loai_PB, pi_English);
            }
            else
            {
                table = oDataAcess.VTH02A_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Nh_Dt, ps_Ma_Dt, ps_Ma_Nh_Vt, ps_Ma_Vt, ps_Tk_641, ps_Tk_642, ps_Loai_PB, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable VTH02B_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Nh_Dt, object ps_Ma_Dt, object ps_Ma_Nh_Vt, object ps_Ma_Vt, object ps_Tk_641, object ps_Tk_642, object ps_Loai_PB, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.VTH02B_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Nh_Dt, ps_Ma_Dt, ps_Ma_Nh_Vt, ps_Ma_Vt, ps_Tk_641, ps_Tk_642, ps_Loai_PB, pi_English);
            }
            else
            {
                table = oDataAcess.VTH02B_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Nh_Dt, ps_Ma_Dt, ps_Ma_Nh_Vt, ps_Ma_Vt, ps_Tk_641, ps_Tk_642, ps_Loai_PB, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable WCD01_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Kho, object ps_Ma_Nh_Vt, object ps_Ma_Vt, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.WCD01_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Kho, ps_Ma_Nh_Vt, ps_Ma_Vt, pi_English);
            }
            else
            {
                table = oDataAcess.WCD01_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Kho, ps_Ma_Nh_Vt, ps_Ma_Vt, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable TB01_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Kho, object ps_Ma_Nh_Ts, object ps_Ma_Ts, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.TB01_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Kho, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            else
            {
                table = oDataAcess.TB01_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Kho, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }
        public DataTable CC01_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Kho, object ps_Ma_Nh_Ts, object ps_Ma_Ts, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.CC01_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Kho, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            else
            {
                table = oDataAcess.CC01_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Kho, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }
        public DataTable WCD02_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object ps_Ma_Kho, object ps_Ma_Nh_Vt, object ps_Ma_Vt, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.WCD02_Get(ps_Subsidiaries, pd_Ngay_Ct1, ps_Ma_Kho, ps_Ma_Nh_Vt, ps_Ma_Vt, pi_English);
            }
            else
            {
                table = oDataAcess.WCD02_Get(ps_Subsidiaries, pd_Ngay_Ct1, ps_Ma_Kho, ps_Ma_Nh_Vt, ps_Ma_Vt, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable TB02_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object ps_Ma_Kho, object ps_Ma_Nh_Ts, object ps_Ma_Ts, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.TB02_Get(ps_Subsidiaries, pd_Ngay_Ct1, ps_Ma_Kho, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            else
            {
                table = oDataAcess.TB02_Get(ps_Subsidiaries, pd_Ngay_Ct1, ps_Ma_Kho, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }
        public DataTable CC02_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object ps_Ma_Kho, object ps_Ma_Nh_Ts, object ps_Ma_Ts, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.CC02_Get(ps_Subsidiaries, pd_Ngay_Ct1, ps_Ma_Kho, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            else
            {
                table = oDataAcess.CC02_Get(ps_Subsidiaries, pd_Ngay_Ct1, ps_Ma_Kho, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }
        public DataTable BCTDTS_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Bp, object ps_Ma_Nh_Ts, object ps_Ma_Ts, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.BCTDTS_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Bp, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            else
            {
                table = oDataAcess.BCTDTS_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Bp, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable BCTDCC_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Bp, object ps_Ma_Nh_Ts, object ps_Ma_Ts, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.BCTDCC_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Bp, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            else
            {
                table = oDataAcess.BCTDCC_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Bp, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }
        public DataTable BCTDBG_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Bp, object ps_Ma_Nh_Ts, object ps_Ma_Ts, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.BCTDBG_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Bp, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            else
            {
                table = oDataAcess.BCTDBG_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Bp, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }
        public DataTable BCCCBG_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Bp, object ps_Ma_Nh_Ts, object ps_Ma_Ts, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.BCCCBG_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Bp, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            else
            {
                table = oDataAcess.BCCCBG_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Bp, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable BCTDSC_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Bp, object ps_Ma_Nh_Ts, object ps_Ma_Ts, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.BCTDSC_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Bp, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            else
            {
                table = oDataAcess.BCTDSC_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Bp, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable BCTDSC1_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Bp, object ps_Ma_Nh_Ts, object ps_Ma_Ts, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.BCTDSC1_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Bp, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            else
            {
                table = oDataAcess.BCTDSC1_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Bp, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable BCTDSC2_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Bp, object ps_Ma_Nh_Ts, object ps_Ma_Ts, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.BCTDSC2_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Bp, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            else
            {
                table = oDataAcess.BCTDSC2_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Bp, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }
        public DataTable BCCCSC_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Bp, object ps_Ma_Nh_Ts, object ps_Ma_Ts, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.BCCCSC_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Bp, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            else
            {
                table = oDataAcess.BCCCSC_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Bp, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }
        public DataTable WCD02A_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object ps_Ma_Kho, object ps_Ma_Nh_Vt, object ps_Ma_Vt, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.WCD02A_Get(ps_Subsidiaries, pd_Ngay_Ct1, ps_Ma_Kho, ps_Ma_Nh_Vt, ps_Ma_Vt, pi_English);
            }
            else
            {
                table = oDataAcess.WCD02A_Get(ps_Subsidiaries, pd_Ngay_Ct1, ps_Ma_Kho, ps_Ma_Nh_Vt, ps_Ma_Vt, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable TB02A_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object ps_Ma_Kho, object ps_Ma_Nh_Ts, object ps_Ma_Ts, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.TB02A_Get(ps_Subsidiaries, pd_Ngay_Ct1, ps_Ma_Kho, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            else
            {
                table = oDataAcess.TB02A_Get(ps_Subsidiaries, pd_Ngay_Ct1, ps_Ma_Kho, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }
        public DataTable CC02A_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object ps_Ma_Kho, object ps_Ma_Nh_Ts, object ps_Ma_Ts, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.CC02A_Get(ps_Subsidiaries, pd_Ngay_Ct1, ps_Ma_Kho, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            else
            {
                table = oDataAcess.CC02A_Get(ps_Subsidiaries, pd_Ngay_Ct1, ps_Ma_Kho, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }
        public DataTable WCT01_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Kho, object ps_Ma_Vt, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.WCT01_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Kho, ps_Ma_Vt, pi_English);
            }
            else
            {
                table = oDataAcess.WCT01_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Kho, ps_Ma_Vt, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable TBCT01_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Kho, object ps_Ma_Ts, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.TBCT01_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Kho, ps_Ma_Ts, pi_English);
            }
            else
            {
                table = oDataAcess.TBCT01_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_Kho, ps_Ma_Ts, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable KTSS_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object pi_Check_Type, object ps_Tk, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.KTSS_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, pi_Check_Type, ps_Tk, pi_English);
            }
            else
            {
                table = oDataAcess.KTSS_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, pi_Check_Type, ps_Tk, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable Check_Error_Get()
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.Check_Error_Get();
            }
            else
            {
                table = oDataAcess.Check_Error_Get();
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable SCTB01_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_BoPhan, object ps_Ma_Nh_Ts, object ps_Ma_Ts, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.SCTB01_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_BoPhan, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            else
            {
                table = oDataAcess.SCTB01_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_BoPhan, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }
        public DataTable SCCC01_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_BoPhan, object ps_Ma_Nh_Ts, object ps_Ma_Ts, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.SCCC01_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_BoPhan, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            else
            {
                table = oDataAcess.SCCC01_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_BoPhan, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }
        public DataTable TB03_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object ps_Ma_Nh_Ts, object ps_Ma_Ts, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.TB03_Get(ps_Subsidiaries, pd_Ngay_Ct1, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            else
            {
                table = oDataAcess.TB03_Get(ps_Subsidiaries, pd_Ngay_Ct1, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable TLTB01_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_BoPhan, object ps_Ma_Nh_Ts, object ps_Ma_Ts, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.TLTB01_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_BoPhan, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            else
            {
                table = oDataAcess.TLTB01_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_BoPhan, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }
        public DataTable TLCC01_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_BoPhan, object ps_Ma_Nh_Ts, object ps_Ma_Ts, object pi_English)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.TLCC01_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_BoPhan, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            else
            {
                table = oDataAcess.TLCC01_Get(ps_Subsidiaries, pd_Ngay_Ct1, pd_Ngay_Ct2, ps_Ma_BoPhan, ps_Ma_Nh_Ts, ps_Ma_Ts, pi_English);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }

        public DataTable BCTinhTrangTS_Get(object ps_Subsidiaries, object p_Ngay, object p_Type_TS, object p_Type)
        {
            DataTable table = null;
            if (AdapterInstance.IsRemoteConnected)
            {
                table = wDataAcess.BCTinhTrangTS_Get(ps_Subsidiaries, p_Ngay, p_Type_TS, p_Type);
            }
            else
            {
                table = oDataAcess.BCTinhTrangTS_Get(ps_Subsidiaries, p_Ngay, p_Type_TS, p_Type);
            }
            if (table != null) table.TableName = string.Empty;
            return table;
        }
    }
}